package ReefStats::Schema::ReefStatsDB::ReasonsAll;

use strict;
use warnings;

use base 'DBIx::Class';

__PACKAGE__->load_components("Core");
__PACKAGE__->table("reasons_all");
__PACKAGE__->add_columns(
    day => {
        data_type     => "DATE",
        default_value => undef,
        is_nullable   => 0,
        size          => 10
    },
    cluster => {
        data_type     => 'varchar',
        default_value => undef,
        is_nullable   => 0,
        size          => 100
    },
    reason => {
        data_type     => 'varchar',
        default_value => undef,
        is_nullable   => 0,
        size          => 20
    },
    number => {
        data_type     => "MEDIUMINT",
        default_value => undef,
        is_nullable   => 0,
        size          => 8,
    },
);

__PACKAGE__->set_primary_key(qw(day cluster reason));

1;
